ADO.NET Dataspecifieke klassen
Bijvoorbeeld, de SqlConnection
en de OleDbConnection
klasse zijn afgeleid van de klasse DbConnection
, die op zijn beurt de IDbConnection
-interface implementeert. De volgende tabel bevat de database specifieke klassen:
Klassen |
Beschrijving |
SqlCommand, OleDbCommand, and ODBCCommand |
Used as wrappers for SQL statements or stored procedure calls. |
SqlCommandBuilder, OleDbCommandBuilder, and ODBCCommandBuilder |
Used to generate SQL commands (such as INSERT, UPDATE, and DELETE statements) from a SELECT statement. |
SqlConnection, OleDbConnection, and ODBCConnection |
Used to connect to the database. |
SqlDataAdapter, OleDbDataAdapter, and ODBCDataAdapter |
Used to hold select, insert, update, and delete commands, which are then used to populate a DataSet and update the database. |
SqlDataReader, OleDbDataReader, and ODBCDataReader |
Used as a forward-only connected data reader. |
SqlParameter, OleDbParameter, and ODBCParameter |
Used to defi ne a parameter to a stored procedure. |
SqlTransaction, OleDbTransaction, and ODBCTransaction |
Used for a database transaction, wrapped in an object. |